SELECT Id FROM new_searchtable
where town = 'Bristol' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Bristol NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Own a stunning Queen Anne Victorian built in 1904 by true craftsmen with income potential from rental units that will pay your mortgage! Though fully renovated the house retains many original features: 4 bronze fireplaces, wood floors, ornate woodwork & wainscoting, stained glass and a magnificent porch. The 1st floor comprises two sitting rooms, one w/woodstove, dining room, office & eat-in kitchen with a soapstone sink, soapstone island, gas range, and original wood cook stove. The kitchen has incredible storage space with both a cooks pantry and a butlers pantry. There are two half-baths on this floor. The 2nd floor has five bedrooms all with their own updated bathrooms, and the third floor, currently used as the primary, has a spacious bedroom and bathroom with two walk-in closets and an additional small bedroom or storage room. Every room has been thoroughly renovated to today's standards with attention to detail. Modern systems include 50+ year roof, zoned FHW baseboard heat, town water and sewer. In addition to the main house, the separate Carriage House has been converted into three apartments which can be used as Airbnb rentals or long-term rentals. The quarter-acre back lot offers room for expansion also. Steps to downtown and two rivers and only two miles from Newfound Lake. This listing is for the real estate only. Turnkey business or furnishings available for additional price. Showings are by appointment only.